[dbo].[Affect_Name

[dbo].[Affect_Name_ie]

SQLServer > iMIS1521GA > Tables > dbo.Affect_Name_ie

Properties
Columns
SQL Script
Uses

Property	Value
Heap
Row Count	0
Created	10:31:13 AM Tuesday, March 02, 2010
Last Modified	10:31:13 AM Tuesday, March 02, 2010

Columns

Name	Data Type	Max Length (Bytes)	Default
ID	varchar(10)	10	('')
CO_ID	varchar(10)	10	('')
BT_ID	varchar(10)	10	('')

SQL Script

CREATE TABLE [dbo].[Affect_Name_ie]
(
[ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Affect_Name_ie_ID] DEFAULT (''),
[CO_ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Affect_Name_ie_CO_ID] DEFAULT (''),
[BT_ID] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Affect_Name_ie_BT_ID] DEFAULT ('')
) ON [PRIMARY]

GO

Uses